﻿<?xml version="1.0" encoding="utf-8" ?>

<DataBase TablePrefix="T_" >

  <Entity Name="Application" Type="primary" Schema="dbo" GenerateCrudSproc="true" AddAuditColumns="true" AddAltPk="true" >
    <Columns>
      <Column Name="ApplicationId" DataType="Int" IsPk="true" />
      <Column Name="ApplicationName" DataType="Char(25)" Nullable="false"  />
      <Column Name="ApplicationType" DataType="Char(02)" Nullable="false"  />
    </Columns>
    <Keys/>
  </Entity>

  <Entity Name="Release" Type="dependent" Schema="dbo" GenerateCrudSproc="false" AddAuditColumns="true" AddAltPk="true" >
    <Columns>
      <Column Name="ApplicationId" DataType="Int" IsPk="true" />
      <Column Name="ReleaseSeq" DataType="Int" IsPk="true"  />
      <Column Name="ReleaseName" DataType="Char(25)" Nullable="false"  />
    </Columns>
    <Keys>
      <Key Name="HelloDaveId" ReferenceName="Application" />
    </Keys>
  </Entity>

  <Entity Name="Iteration" Type="dependent" Schema="dbo" GenerateCrudSproc="false" AddAuditColumns="true" AddAltPk="true" >
    <Columns>
      <Column Name="ApplicationId" DataType="Int" IsPk="true" />
      <Column Name="ReleaseSeq" DataType="Int" IsPk="true" />
      <Column Name="IterationSeq" DataType="Int" IsPk="true" />
      <Column Name="IterationBegin" DataType="datetime" Nullable="false"  />
    </Columns>
    <Keys>
      <Key Name="Release" ReferenceName="Release" />
    </Keys>
  </Entity>

</DataBase>

